-- ----------------------------- 2023-07-20 add by zhoujq--------------begin

-- 建表语句
CREATE TABLE T_LIMS_PJ_REPORT( 
    ID NUMBER NOT NULL,
    REPORTNO VARCHAR2(50)  NULL,
    BATCHID NUMBER NULL,
    BATCHCODE VARCHAR2(50)  NULL,
    PRODUCTID NUMBER NULL,
    PRODUCTCODE VARCHAR2(100)  NULL,
    PRODUCTNAME VARCHAR2(200)  NULL,
    SAMPLEIDS VARCHAR2(400)  NULL,
    SAMPLECODES VARCHAR2(400)  NULL,
    FOLDERIDS VARCHAR2(400)  NULL,
    FOLDERCODES VARCHAR2(400)  NULL,
    REPORTTEMPLATEID NUMBER NULL,
    REPORTTEMPLATECODE VARCHAR2(100)  NULL,
    REPORTTEMPLATENAME VARCHAR2(200)  NULL,
    GENERATORID VARCHAR2(50)  NULL,
    GENERATOR VARCHAR2(100)  NULL,
    SIGNERID VARCHAR2(50)  NULL,
    SIGNER VARCHAR2(100)  NULL,
    AUDITTIME DATE NULL,
    REMARK VARCHAR2(200)  NULL,
    REPORTFILEID NUMBER NULL,
    REPORTFILENAME VARCHAR2(200)  NULL,
    TYPE VARCHAR2(10)  NULL,
    PROCESSSTATUS VARCHAR2(36)  NULL,
    CREATEDBYID VARCHAR2(36)  NULL,
    CREATEDBYNAME VARCHAR2(60)  NULL,
    CREATEDTIME DATE NULL,
    CREATEDBYORGID VARCHAR2(36)  NULL,
    CREATEDBYORGNAME VARCHAR2(270)  NULL
 );
COMMENT ON TABLE T_LIMS_PJ_REPORT IS '普检检测报告';
COMMENT ON COLUMN T_LIMS_PJ_REPORT.ID IS '主键';
COMMENT ON COLUMN T_LIMS_PJ_REPORT.REPORTNO IS '报告编号';
COMMENT ON COLUMN T_LIMS_PJ_REPORT.BATCHID IS '订单ID';
COMMENT ON COLUMN T_LIMS_PJ_REPORT.BATCHCODE IS '订单编号';
COMMENT ON COLUMN T_LIMS_PJ_REPORT.PRODUCTID IS '产品Id';
COMMENT ON COLUMN T_LIMS_PJ_REPORT.PRODUCTCODE IS '产品编号';
COMMENT ON COLUMN T_LIMS_PJ_REPORT.PRODUCTNAME IS '产品名称';
COMMENT ON COLUMN T_LIMS_PJ_REPORT.SAMPLEIDS IS '样本Id';
COMMENT ON COLUMN T_LIMS_PJ_REPORT.SAMPLECODES IS '样本编号';
COMMENT ON COLUMN T_LIMS_PJ_REPORT.FOLDERIDS IS '任务单Id';
COMMENT ON COLUMN T_LIMS_PJ_REPORT.FOLDERCODES IS '任务单编号';
COMMENT ON COLUMN T_LIMS_PJ_REPORT.REPORTTEMPLATEID IS '报告模板Id';
COMMENT ON COLUMN T_LIMS_PJ_REPORT.REPORTTEMPLATECODE IS '报告模板编号';
COMMENT ON COLUMN T_LIMS_PJ_REPORT.REPORTTEMPLATENAME IS '报告模板名称';
COMMENT ON COLUMN T_LIMS_PJ_REPORT.GENERATORID IS '生成人id';
COMMENT ON COLUMN T_LIMS_PJ_REPORT.GENERATOR IS '生成人';
COMMENT ON COLUMN T_LIMS_PJ_REPORT.SIGNERID IS '签发人id';
COMMENT ON COLUMN T_LIMS_PJ_REPORT.SIGNER IS '签发人';
COMMENT ON COLUMN T_LIMS_PJ_REPORT.AUDITTIME IS '报告审核时间';
COMMENT ON COLUMN T_LIMS_PJ_REPORT.REMARK IS '备注';
COMMENT ON COLUMN T_LIMS_PJ_REPORT.REPORTFILEID IS '报告文件ID';
COMMENT ON COLUMN T_LIMS_PJ_REPORT.REPORTFILENAME IS '报告文件名称';
COMMENT ON COLUMN T_LIMS_PJ_REPORT.TYPE IS '普检or特检';
COMMENT ON COLUMN T_LIMS_PJ_REPORT.PROCESSSTATUS IS '流程状态';
COMMENT ON COLUMN T_LIMS_PJ_REPORT.CREATEDBYID IS '制单人编码';
COMMENT ON COLUMN T_LIMS_PJ_REPORT.CREATEDBYNAME IS '制单人名称';
COMMENT ON COLUMN T_LIMS_PJ_REPORT.CREATEDTIME IS '制单时间';
COMMENT ON COLUMN T_LIMS_PJ_REPORT.CREATEDBYORGID IS '制单人单位编码';
COMMENT ON COLUMN T_LIMS_PJ_REPORT.CREATEDBYORGNAME IS '制单人单位名称';

ALTER TABLE T_LIMS_PJ_REPORT ADD CONSTRAINT PK_LIMS_PJ_REPORT PRIMARY KEY (ID);

-- 旧版审计跟踪，跟踪配置变更语句

INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PJ_REPORT','ID','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PJ_REPORT','REPORTNO','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PJ_REPORT','BATCHID','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PJ_REPORT','BATCHCODE','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PJ_REPORT','PRODUCTID','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PJ_REPORT','PRODUCTCODE','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PJ_REPORT','PRODUCTNAME','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PJ_REPORT','SAMPLEIDS','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PJ_REPORT','SAMPLECODES','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PJ_REPORT','FOLDERIDS','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PJ_REPORT','FOLDERCODES','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PJ_REPORT','REPORTTEMPLATEID','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PJ_REPORT','REPORTTEMPLATECODE','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PJ_REPORT','REPORTTEMPLATENAME','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PJ_REPORT','GENERATORID','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PJ_REPORT','GENERATOR','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PJ_REPORT','SIGNERID','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PJ_REPORT','SIGNER','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PJ_REPORT','AUDITTIME','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PJ_REPORT','REMARK','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PJ_REPORT','REPORTFILEID','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PJ_REPORT','REPORTFILENAME','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PJ_REPORT','TYPE','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PJ_REPORT','PROCESSSTATUS','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PJ_REPORT','CREATEDBYID','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PJ_REPORT','CREATEDBYNAME','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PJ_REPORT','CREATEDTIME','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PJ_REPORT','CREATEDBYORGID','1',CURRENT_TIMESTAMP);
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDTIME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PJ_REPORT','CREATEDBYORGNAME','1',CURRENT_TIMESTAMP);
COMMIT;

-- 审计跟踪V2，跟踪配置变更语句

INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PJ_REPORT','ID','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PJ_REPORT','REPORTNO','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PJ_REPORT','BATCHID','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PJ_REPORT','BATCHCODE','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PJ_REPORT','PRODUCTID','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PJ_REPORT','PRODUCTCODE','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PJ_REPORT','PRODUCTNAME','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PJ_REPORT','SAMPLEIDS','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PJ_REPORT','SAMPLECODES','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PJ_REPORT','FOLDERIDS','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PJ_REPORT','FOLDERCODES','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PJ_REPORT','REPORTTEMPLATEID','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PJ_REPORT','REPORTTEMPLATECODE','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PJ_REPORT','REPORTTEMPLATENAME','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PJ_REPORT','GENERATORID','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PJ_REPORT','GENERATOR','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PJ_REPORT','SIGNERID','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PJ_REPORT','SIGNER','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PJ_REPORT','AUDITTIME','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PJ_REPORT','REMARK','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PJ_REPORT','REPORTFILEID','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PJ_REPORT','REPORTFILENAME','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PJ_REPORT','TYPE','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PJ_REPORT','PROCESSSTATUS','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PJ_REPORT','CREATEDBYID','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PJ_REPORT','CREATEDBYNAME','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PJ_REPORT','CREATEDTIME','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PJ_REPORT','CREATEDBYORGID','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_PJ_REPORT','CREATEDBYORGNAME','1');
COMMIT;
CALL INSERTI18N('T_LIMS_PJ_REPORT.SERVICE_NAME', '普检检测报告', '普检检测报告', 'zh-CN', '普检检测报告');
CALL INSERTI18N('T_LIMS_PJ_REPORT.ID', '普检检测报告的主键', '主键', 'zh-CN', '主键');
CALL INSERTI18N('T_LIMS_PJ_REPORT.REPORTNO', '普检检测报告的报告编号', '报告编号', 'zh-CN', '报告编号');
CALL INSERTI18N('T_LIMS_PJ_REPORT.BATCHID', '普检检测报告的订单ID', '订单ID', 'zh-CN', '订单ID');
CALL INSERTI18N('T_LIMS_PJ_REPORT.BATCHCODE', '普检检测报告的订单编号', '订单编号', 'zh-CN', '订单编号');
CALL INSERTI18N('T_LIMS_PJ_REPORT.PRODUCTID', '普检检测报告的产品Id', '产品Id', 'zh-CN', '产品Id');
CALL INSERTI18N('T_LIMS_PJ_REPORT.PRODUCTCODE', '普检检测报告的产品编号', '产品编号', 'zh-CN', '产品编号');
CALL INSERTI18N('T_LIMS_PJ_REPORT.PRODUCTNAME', '普检检测报告的产品名称', '产品名称', 'zh-CN', '产品名称');
CALL INSERTI18N('T_LIMS_PJ_REPORT.SAMPLEIDS', '普检检测报告的样本Id', '样本Id', 'zh-CN', '样本Id');
CALL INSERTI18N('T_LIMS_PJ_REPORT.SAMPLECODES', '普检检测报告的样本编号', '样本编号', 'zh-CN', '样本编号');
CALL INSERTI18N('T_LIMS_PJ_REPORT.FOLDERIDS', '普检检测报告的任务单Id', '任务单Id', 'zh-CN', '任务单Id');
CALL INSERTI18N('T_LIMS_PJ_REPORT.FOLDERCODES', '普检检测报告的任务单编号', '任务单编号', 'zh-CN', '任务单编号');
CALL INSERTI18N('T_LIMS_PJ_REPORT.REPORTTEMPLATEID', '普检检测报告的报告模板Id', '报告模板Id', 'zh-CN', '报告模板Id');
CALL INSERTI18N('T_LIMS_PJ_REPORT.REPORTTEMPLATECODE', '普检检测报告的报告模板编号', '报告模板编号', 'zh-CN', '报告模板编号');
CALL INSERTI18N('T_LIMS_PJ_REPORT.REPORTTEMPLATENAME', '普检检测报告的报告模板名称', '报告模板名称', 'zh-CN', '报告模板名称');
CALL INSERTI18N('T_LIMS_PJ_REPORT.GENERATORID', '普检检测报告的生成人id', '生成人id', 'zh-CN', '生成人id');
CALL INSERTI18N('T_LIMS_PJ_REPORT.GENERATOR', '普检检测报告的生成人', '生成人', 'zh-CN', '生成人');
CALL INSERTI18N('T_LIMS_PJ_REPORT.SIGNERID', '普检检测报告的签发人id', '签发人id', 'zh-CN', '签发人id');
CALL INSERTI18N('T_LIMS_PJ_REPORT.SIGNER', '普检检测报告的签发人', '签发人', 'zh-CN', '签发人');
CALL INSERTI18N('T_LIMS_PJ_REPORT.AUDITTIME', '普检检测报告的报告审核时间', '报告审核时间', 'zh-CN', '报告审核时间');
CALL INSERTI18N('T_LIMS_PJ_REPORT.REMARK', '普检检测报告的备注', '备注', 'zh-CN', '备注');
CALL INSERTI18N('T_LIMS_PJ_REPORT.REPORTFILEID', '普检检测报告的报告文件ID', '报告文件ID', 'zh-CN', '报告文件ID');
CALL INSERTI18N('T_LIMS_PJ_REPORT.REPORTFILENAME', '普检检测报告的报告文件名称', '报告文件名称', 'zh-CN', '报告文件名称');
CALL INSERTI18N('T_LIMS_PJ_REPORT.TYPE', '普检检测报告的普检or特检', '普检or特检', 'zh-CN', '普检or特检');
CALL INSERTI18N('T_LIMS_PJ_REPORT.PROCESSSTATUS', '普检检测报告的流程状态', '流程状态', 'zh-CN', '流程状态');
CALL INSERTI18N('T_LIMS_PJ_REPORT.CREATEDBYID', '普检检测报告的制单人编码', '制单人编码', 'zh-CN', '制单人编码');
CALL INSERTI18N('T_LIMS_PJ_REPORT.CREATEDBYNAME', '普检检测报告的制单人名称', '制单人名称', 'zh-CN', '制单人名称');
CALL INSERTI18N('T_LIMS_PJ_REPORT.CREATEDTIME', '普检检测报告的制单时间', '制单时间', 'zh-CN', '制单时间');
CALL INSERTI18N('T_LIMS_PJ_REPORT.CREATEDBYORGID', '普检检测报告的制单人单位编码', '制单人单位编码', 'zh-CN', '制单人单位编码');
CALL INSERTI18N('T_LIMS_PJ_REPORT.CREATEDBYORGNAME', '普检检测报告的制单人单位名称', '制单人单位名称', 'zh-CN', '制单人单位名称');
CALL INSERTI18N('BASEMODULE.BUSINESS.PJREPORTS.MODAL.ADD', '新增', '新增', 'zh-CN', '新增');
CALL INSERTI18N('BASEMODULE.BUSINESS.PJREPORTS.TAB.BASE_INFO', '基本信息', '基本信息', 'zh-CN', '基本信息');
CALL INSERTI18N('BASEMODULE.BUSINESS.PJREPORTS.BUTTON.BUTTON', '按钮', '按钮', 'zh-CN', '按钮');
CALL INSERTI18N('BASEMODULE.BUSINESS.PJREPORTS.TIP.TIP', '提示框', '提示框', 'zh-CN', '提示框');
CALL INSERTI18N('BASEMODULE.BUSINESS.PJREPORTS.MODAL.MODAL', '对话框', '对话框', 'zh-CN', '对话框');

-- 创建菜单语句
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
VALUES ('2023072001', '普检报告', '/secure/basemodule/business/pj-reports/page/edit-list', 'null', '2023072001', 'null', '普检报告');

INSERT INTO T_CORE_TABLE (ID, AUDITABLE, ATTACHMENT)
VALUES ('T_LIMS_PJ_REPORT', '1', '0');

INSERT INTO T_CORE_MENU_EXT (ID, SERVICENAME, TABLENAME, TYPE, ENABLE)
VALUES ('2023072001', '普检报告', 'T_LIMS_PJ_REPORT', 'audit_def', '1');


COMMIT;

-- ----------------------------- 2023-07-20 add by zhoujq------------end